-- @author tongdanyu
-- @date 20230710
-- C侧罗盘数据指标-日活、简历、流量、留存

CREATE EXTERNAL TABLE `hdp_lbg_supin_zplisting.app_zp_n_luopan_data`(
     platform string comment '端'
    ,source_type string comment '渠道来源'
    ,dau bigint comment '日活'
    ,dau_full bigint comment '全职日活'
    ,dau_part bigint comment '兼职日活'
    ,login_uv bigint comment '登陆uv'
    ,login_no_resume_uv bigint comment '登陆无简历uv'
    ,new_resume_uv bigint comment '新增简历uv'
    ,search_as bigint comment '检索as'
    ,search_uv bigint comment '检索uv'
    ,exp_as bigint comment '真实曝光as'
    ,exp_uv bigint comment '真实曝光uv'
    ,click_epv bigint comment '详情点击pv'
    ,click_uv bigint comment '详情点击uv'
    ,link_cnt bigint comment '连接量'
    ,link_uv bigint comment '连接uv'
    ,link_cnt_bsend bigint comment 'b发起连接量'
    ,link_uv_bsend bigint comment 'b发起连接量uv'
    ,link_cnt_csend bigint comment 'c发起连接量'
    ,link_uv_csend bigint comment 'c发起连接量uv'
    ,link_cnt_valid bigint comment '有效连接量'
    ,link_uv_valid bigint comment '有效连接uv'
    ,dau1 bigint comment '前一天活跃在当天的留存人数'
    ,dau7 bigint comment '前7日活跃在当天的的留存人数'
    ,new_dau1 bigint comment '新用户前一天活跃在当天的留存人数'
    ,new_dau7 bigint comment '新用户前7日活跃在当天的的留存人数'
)comment 'C端用户核心指标数据'
partitioned by (`dt` string comment '日期(yyyyMMdd)')
stored as parquet
location 'viewfs://58-cluster/home/hdp_lbg_supin/resultdata/offline_warehouse3/n/app/app_zp_n_luopan_data'
tblproperties ('parquet.compress'='snappy')